#!/bin/bash

read -p "please input database name:" u_dbname
mysql -uroot -p123123 <<EOF
  create database $u_dbname;
  show databases;
  quit
EOF
echo "create database $u_dbname ok"
